use [SystemConfig]
GO

/****** Object:  Table [dbo].[MdsConfiguration]    Script Date: 2014/8/27 15:17:27 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[MdsConfiguration](
	[Id] [uniqueidentifier] NOT NULL,
	[Title] [nvarchar](500) NOT NULL,
	[Version] [int] NULL,
	[Content] [xml] NULL,
	[ServiceId] [uniqueidentifier] NOT NULL,
	[ServiceName] [nvarchar](500) NULL,
	[Enable] [bit] NULL,
	[SolutionId] [uniqueidentifier] NOT NULL,
	[AppclationId] [uniqueidentifier] NOT NULL,
	[CreateTime] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

ALTER TABLE [dbo].[MdsConfiguration] ADD  CONSTRAINT [DF_MdsConfiguration_Version]  DEFAULT ((0)) FOR [Version]
GO

ALTER TABLE [dbo].[MdsConfiguration] ADD  CONSTRAINT [DF_MdsConfiguration_Enable]  DEFAULT ((0)) FOR [Enable]
GO

ALTER TABLE [dbo].[MdsConfiguration] ADD  CONSTRAINT [DF_MdsConfiguration_CreateTime]  DEFAULT (getdate()) FOR [CreateTime]
GO


